package com.tools.automatic_clock.dao;

import com.tools.automatic_clock.bean.account;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface studentMapper {
    @Select("select snum from account")
    List<Integer> numList();
    @Select("select * from account where snum = #{snum}")
    account select_num(Integer snum);
    @Select("SELECT DATEDIFF(NOW(),DATE) FROM ACCOUNT where snum = #{snum}")
    int elapsedDate(Integer snum);
    @Select("select type from account where snum = #{snum}")
    int type(Integer snum);
}
